Help with IF

Candi80 

You can create a single formula to calculate the total inventory amount by subtracting the sale amounts for items with sale dates. You can use the SUMIFS function to achieve this. Here's how:

Assuming you have your RV inventory data in columns A (RV Model), B (Inventory Amount), and C (Sale Date), and you want to calculate the total inventory amount in a single cell (e.g., in a cell at the bottom of your inventory list), you can do the following:

1. In a cell (e.g., cell B10), enter the following formula to calculate the total inventory amount:

=SUM(B2:B9) - SUMIFS(B2:B9, C2:C9, "<>")

Here is what this formula does:

• SUM(B2:B9) calculates the sum of all inventory amounts in the range B2:B9 (adjust the range to cover all your inventory items except the total cell).
• SUMIFS(B2:B9, C2:C9, "<>") calculates the sum of inventory amounts in the same range (B2:B9) where the corresponding sale date in column C (C2:C9) is not empty (i.e., there's a sale date).
• Subtracting the second sum from the first sum effectively subtracts the sale amounts from the total inventory.

Now, when you update your inventory and add sale dates, the total inventory amount in cell B10 will automatically reflect the correct total after deducting the sold items. Just make sure to adjust the cell references (B2:B9 and C2:C9) to match the actual range of your inventory data. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark them as helpful and like it!

This will help all forum participants.